Release 10.1A: OpenEdge Development:
Basic Database Tools

Edit Data Security

Choose Security Edit Data Security to define compile-time security for an application database. The Data Dictionary alphabetically lists the names of the tables defined for the working database. When you select a table, the Data Dictionary displays the current permissions lists for the table. Figure 10–7 shows the default permissions for the customer table.

Figure 10–7: Edit Data Security dialog box

The upper section of the Edit Data Security dialog box displays the six levels of security permissions for the table. By default, the Data Dictionary initializes all levels with an asterisk (*), which means that all users are allowed to modify table permissions. The lower section describes the fields for the permissions lists.

The six levels of security permissions for tables are:

Can-Read

Specifies the users who have permission to read a table. The default is an asterisk (all users).

Can-Write

Specifies the users who can write to a table or update records. The default is an asterisk (all users).

Can-Create

Specifies the users who can create new records. In order to create a new record, a user must have Can-Write privileges. The default is an asterisk (all users).

Can-Delete

Specifies the users who can delete records from a table. The default is an asterisk (all users).

Can-Dump

Specifies whether you can dump database or table definitions and data with triggers disabled. The default is an asterisk (all users).

Can-Load

Specifies whether you can load database or table definitions and data with triggers disabled. The default is an asterisk (all users).

Table 10–7 describes the values you use to define the permissions for a table.

Table 10–7: Access restrictions for tables 

Expression	Meaning
*	All users are allowed access.
user	Only this user has access.
! user, *	All users have access except this user. Note: Do not place the asterisk (*) before !user. If you do, all users are allowed access.
acct*	User IDs that begin with acct have access.

Table 10–8 describes the options at the bottom of the Edit Data Security dialog box.

Table 10–8: Edit Data Security dialog box options 

Option	Action
NextField	Displays the next field defined for the specified table.
PrevField	Displays the previous field defined for the specified table.
ForwardFile	Displays the permissions for the next table defined for the working database.
Modify	Modifies the permissions for a table or field.
SwitchFile	Displays the list of tables again so you can select a new table.
JumpField	Displays a list of all the fields defined for the current table.
CallAdmin	Accesses the Security Administrators dialog box.
Security	Accesses the Data Security option dialog box.
Report	Generates a user report for the working database.
Exit	Exits, saves changes, and returns to the Data Dictionary window.

Once you designate security administrators, only they can use this option.